﻿CREATE TABLE [Core].[Contact] (
    [ContactId]       UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL,
    [FirstName]       NVARCHAR (50)    NOT NULL,
    [Middle]          NVARCHAR (50)    NULL,
    [LastName]        NVARCHAR (50)    NULL,
    [FullName]        AS               (([FirstName]+isnull(' '+[Middle],''))+isnull(' '+[LastName],'')),
    [Email]           NVARCHAR (127)   NOT NULL,
    [OtherEmail]      NVARCHAR (127)   NULL,
    [WorkPhone]       NVARCHAR (15)    NULL,
    [CellPhone]       NVARCHAR (15)    NULL,
    [HomePhone]       NVARCHAR (15)    NULL,
    [OtherPhone]      NVARCHAR (15)    NULL,
    [Status]          NCHAR (1)        NOT NULL,
    [EmailVerifiedYN] NCHAR (1)        NOT NULL,
    [IsDroppedYN]     NCHAR (1)        NOT NULL,
    [CreatedDT]       DATETIME         NOT NULL,
    [CreatedById]     UNIQUEIDENTIFIER NOT NULL,
    [CreatedByName]   NVARCHAR (127)   NOT NULL,
    [ModifiedDT]      DATETIME         NOT NULL,
    [ModifiedById]    UNIQUEIDENTIFIER NOT NULL,
    [ModifiedByName]  NVARCHAR (127)   NOT NULL
);

